﻿USE WRMO
GO
--SELECT * FROM dbo.WRLANGUAGE

INSERT INTO dbo.WRLANGUAGE VALUES (N'English', 'en', GETDATE(), GETDATE(), NULL, N'English language', 'Y', 'english')
INSERT INTO dbo.WRLANGUAGE VALUES (N'Vietnamese', 'vn', GETDATE(), GETDATE(), NULL, N'Ngôn ngữ Tiếng Việt', 'Y', 'vietnamese')

--SELECT * FROM dbo.WRCITIZEN

INSERT INTO  dbo.WRCITIZEN VALUES (N'English', N'+1', GETDATE(), GETDATE(), NULL, N'', 'Y', N'english')
INSERT INTO  dbo.WRCITIZEN VALUES (N'Canada', N'+1', GETDATE(), GETDATE(), NULL, N'', 'Y', N'canada')
INSERT INTO  dbo.WRCITIZEN VALUES (N'Vietnam', N'+84', GETDATE(), GETDATE(), NULL, N'', 'Y', N'vietnam')

--SELECT * FROM dbo.WRAREA

INSERT INTO  dbo.WRAREA VALUES ('Alberta', 'AB', GETDATE(), NULL, GETDATE(), NULL, 1, '', 'Y', 'alberta')
INSERT INTO  dbo.WRAREA VALUES ('British Columbia', 'BC', GETDATE(), NULL, GETDATE(), NULL, 1, '', 'Y', 'british-columbia')
INSERT INTO  dbo.WRAREA VALUES ('Manitoba', 'MB', GETDATE(), NULL, GETDATE(), NULL, 1, '', 'Y', 'manitoba')
INSERT INTO  dbo.WRAREA VALUES ('New Brunswick', 'NB', GETDATE(), NULL, GETDATE(), NULL, 1, '', 'Y', 'new-bruncswick')
INSERT INTO  dbo.WRAREA VALUES ('Northwest Territories', 'NT', GETDATE(), NULL, GETDATE(), NULL, 1, '', 'Y', 'northwest-territories')
INSERT INTO  dbo.WRAREA VALUES ('Newfoundland', 'NL', GETDATE(), NULL, GETDATE(), NULL, 1, '', 'Y', 'newfoundland')
INSERT INTO  dbo.WRAREA VALUES ('Nova Scotia', 'NS', GETDATE(), NULL, GETDATE(), NULL, 1, '', 'Y', 'nova-scotia')
INSERT INTO  dbo.WRAREA VALUES ('Ontario (A - L)', 'ONAL', GETDATE(), NULL, GETDATE(), NULL, 1, '', 'Y', 'ontario-al')
INSERT INTO  dbo.WRAREA VALUES ('Ontario (M - Z)', 'ONMZ', GETDATE(), NULL, GETDATE(), NULL, 1, '', 'Y', 'ontario-mz')
INSERT INTO  dbo.WRAREA VALUES ('Prince Edward Island', 'PE', GETDATE(), NULL, GETDATE(), NULL, 1, '', 'Y', 'prince-edward-island')
INSERT INTO  dbo.WRAREA VALUES ('Québec', 'QC', GETDATE(), NULL, GETDATE(), NULL, 1, '', 'Y', 'quebec')
INSERT INTO  dbo.WRAREA VALUES ('Saskatchewan', 'SK', GETDATE(), NULL, GETDATE(), NULL, 1, '', 'Y', 'sakatchewan')

INSERT INTO  dbo.WRAREA VALUES (N'Việt Nam', 'VN', GETDATE(), NULL, GETDATE(), NULL, 2, '', 'Y', 'viet-nam')

--SELECT * FROM dbo.WRREGION
--DELETE dbo.WRREGION

INSERT INTO dbo.WRREGION VALUES ('Banff / Canmore','66', GETDATE(), NULL, GETDATE(), NULL, 1, '', 'Y', 'banff/canmore')
INSERT INTO dbo.WRREGION VALUES ('Calgary','403', GETDATE(), NULL, GETDATE(), NULL, 1, '', 'Y', 'calagry') 
INSERT INTO dbo.WRREGION VALUES ('Edmonton Area','587', GETDATE(), NULL, GETDATE(), NULL, 1, '', 'Y', 'edmonton-area')
INSERT INTO dbo.WRREGION VALUES ('Fort McMurray','587', GETDATE(), NULL, GETDATE(), NULL, 1, '', 'Y', 'fort-mcmurray')
INSERT INTO dbo.WRREGION VALUES ('Grande Prairie','587', GETDATE(), NULL, GETDATE(), NULL, 1, '', 'Y', 'grande-prairie')
INSERT INTO dbo.WRREGION VALUES ('Lethbridge','403', GETDATE(), NULL, GETDATE(), NULL, 1, '', 'Y', 'lethbridge')
INSERT INTO dbo.WRREGION VALUES ('Lloydminster','306', GETDATE(), NULL, GETDATE(), NULL, 1, '', 'Y', 'lloydminster')
INSERT INTO dbo.WRREGION VALUES ('Medicine Hat','403', GETDATE(), NULL, GETDATE(), NULL, 1, '', 'Y', 'medicine-hat')
INSERT INTO dbo.WRREGION VALUES ('Red Deer','403', GETDATE(), NULL, GETDATE(), NULL, 1, '', 'Y', 'red-deer')

INSERT INTO dbo.WRREGION VALUES ('Cariboo Area','', GETDATE(), NULL, GETDATE(), NULL, 2, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Comox Valley Area','', GETDATE(), NULL, GETDATE(), NULL, 2, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Cowichan Valley / Duncan','', GETDATE(), NULL, GETDATE(), NULL, 2, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Cranbrook','', GETDATE(), NULL, GETDATE(), NULL, 2, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Fraser Valley','', GETDATE(), NULL, GETDATE(), NULL, 2, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Greater Vancouver Valley','', GETDATE(), NULL, GETDATE(), NULL, 2, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Kamloops','', GETDATE(), NULL, GETDATE(), NULL, 2, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Kelowna','', GETDATE(), NULL, GETDATE(), NULL, 2, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Nanaimo','', GETDATE(), NULL, GETDATE(), NULL, 2, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Nelson','', GETDATE(), NULL, GETDATE(), NULL, 2, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Peace River Area','', GETDATE(), NULL, GETDATE(), NULL, 2, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Port Alberni / Oceanside','', GETDATE(), NULL, GETDATE(), NULL, 2, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Port Hardy / Port McNeill','', GETDATE(), NULL, GETDATE(), NULL, 2, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Powell River Distric','', GETDATE(), NULL, GETDATE(), NULL, 2, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Prince George','', GETDATE(), NULL, GETDATE(), NULL, 2, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Revelstoke','', GETDATE(), NULL, GETDATE(), NULL, 2, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Skeena-Bulkley Area','', GETDATE(), NULL, GETDATE(), NULL, 2, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Sunshine Coast','', GETDATE(), NULL, GETDATE(), NULL, 2, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Vernon','', GETDATE(), NULL, GETDATE(), NULL, 2, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Victoria','', GETDATE(), NULL, GETDATE(), NULL, 2, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Whistler','', GETDATE(), NULL, GETDATE(), NULL, 2, '', 'Y', '')


INSERT INTO dbo.WRREGION VALUES ('Brandon Area','', GETDATE(), NULL, GETDATE(), NULL, 3, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Flin Flon','', GETDATE(), NULL, GETDATE(), NULL, 3, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Thompson','', GETDATE(), NULL, GETDATE(), NULL, 3, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Winnipeg','', GETDATE(), NULL, GETDATE(), NULL, 3, '', 'Y', '')

INSERT INTO dbo.WRREGION VALUES ('Bathurst','', GETDATE(), NULL, GETDATE(), NULL, 4, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Edmundston','', GETDATE(), NULL, GETDATE(), NULL, 4, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Fredericton','', GETDATE(), NULL, GETDATE(), NULL, 4, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Miramichi','', GETDATE(), NULL, GETDATE(), NULL, 4, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Moncton','', GETDATE(), NULL, GETDATE(), NULL, 4, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Saint John','', GETDATE(), NULL, GETDATE(), NULL, 4, '', 'Y', '')

INSERT INTO dbo.WRREGION VALUES ('Corner Brook','', GETDATE(), NULL, GETDATE(), NULL, 5, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Gander','', GETDATE(), NULL, GETDATE(), NULL, 5, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Labrador','', GETDATE(), NULL, GETDATE(), NULL, 5, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('St. Johns','', GETDATE(), NULL, GETDATE(), NULL, 5, '', 'Y', '')

INSERT INTO dbo.WRREGION VALUES ('Annapolis Valley','', GETDATE(), NULL, GETDATE(), NULL, 6, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Bridgewater','', GETDATE(), NULL, GETDATE(), NULL, 6, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Cape Breton','', GETDATE(), NULL, GETDATE(), NULL, 6, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Halifax','', GETDATE(), NULL, GETDATE(), NULL, 6, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('New Glasgow','', GETDATE(), NULL, GETDATE(), NULL, 6, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Trugo','', GETDATE(), NULL, GETDATE(), NULL, 6, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Yarmouth','', GETDATE(), NULL, GETDATE(), NULL, 6, '', 'Y', '')

INSERT INTO dbo.WRREGION VALUES ('Barrie','', GETDATE(), NULL, GETDATE(), NULL, 7, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Belleville Area','', GETDATE(), NULL, GETDATE(), NULL, 7, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Brantford','', GETDATE(), NULL, GETDATE(), NULL, 7, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Brockville','', GETDATE(), NULL, GETDATE(), NULL, 7, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Chalham-Kent','', GETDATE(), NULL, GETDATE(), NULL, 7, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Cornwall','', GETDATE(), NULL, GETDATE(), NULL, 7, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Guelph','', GETDATE(), NULL, GETDATE(), NULL, 7, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Hamilton','', GETDATE(), NULL, GETDATE(), NULL, 7, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Kapuskasing','', GETDATE(), NULL, GETDATE(), NULL, 7, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Kenora','', GETDATE(), NULL, GETDATE(), NULL, 7, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Kingston Area','', GETDATE(), NULL, GETDATE(), NULL, 7, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Kitchener Area','', GETDATE(), NULL, GETDATE(), NULL, 7, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Leamington','', GETDATE(), NULL, GETDATE(), NULL, 7, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('London','', GETDATE(), NULL, GETDATE(), NULL, 7, '', 'Y', '')

INSERT INTO dbo.WRREGION VALUES ('Muskoka','', GETDATE(), NULL, GETDATE(), NULL, 8, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Norfolk','', GETDATE(), NULL, GETDATE(), NULL, 8, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('North Bay','', GETDATE(), NULL, GETDATE(), NULL, 8, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Ottawa / Gatineau Area','', GETDATE(), NULL, GETDATE(), NULL, 8, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Owen Sound','', GETDATE(), NULL, GETDATE(), NULL, 8, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Peterborough Area','', GETDATE(), NULL, GETDATE(), NULL, 8, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Renfrew Country Area','', GETDATE(), NULL, GETDATE(), NULL, 8, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Sarnia Area','', GETDATE(), NULL, GETDATE(), NULL, 8, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Sault Ste. Marie','', GETDATE(), NULL, GETDATE(), NULL, 8, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('St. Catharines','', GETDATE(), NULL, GETDATE(), NULL, 8, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Sudbury','', GETDATE(), NULL, GETDATE(), NULL, 8, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Thunder Bay','', GETDATE(), NULL, GETDATE(), NULL, 8, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Timmins','', GETDATE(), NULL, GETDATE(), NULL, 8, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Toronto (GTA)','', GETDATE(), NULL, GETDATE(), NULL, 8, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Windsor Region','', GETDATE(), NULL, GETDATE(), NULL, 8, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Woodstock','', GETDATE(), NULL, GETDATE(), NULL, 8, '', 'Y', '')

INSERT INTO dbo.WRREGION VALUES ('Prince Edward Island','', GETDATE(), NULL, GETDATE(), NULL, 9, '', 'Y', '')

INSERT INTO dbo.WRREGION VALUES ('Abitibi-Temiscamingue','', GETDATE(), NULL, GETDATE(), NULL, 10, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Baie-Comeau','', GETDATE(), NULL, GETDATE(), NULL, 10, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Centre-du-Québec','', GETDATE(), NULL, GETDATE(), NULL, 10, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Chaudière-Appalaches','', GETDATE(), NULL, GETDATE(), NULL, 10, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Chibougamau / Northern Québec','', GETDATE(), NULL, GETDATE(), NULL, 10, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Gaspé','', GETDATE(), NULL, GETDATE(), NULL, 10, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Granby','', GETDATE(), NULL, GETDATE(), NULL, 10, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Greater Montréal','', GETDATE(), NULL, GETDATE(), NULL, 10, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Lanaudière','', GETDATE(), NULL, GETDATE(), NULL, 10, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Laurentides','', GETDATE(), NULL, GETDATE(), NULL, 10, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Mauricie','', GETDATE(), NULL, GETDATE(), NULL, 10, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Québec City','', GETDATE(), NULL, GETDATE(), NULL, 10, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Rimouski / Bas-St-Laurent','', GETDATE(), NULL, GETDATE(), NULL, 10, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Saguenay-Lac-Saint-Jean','', GETDATE(), NULL, GETDATE(), NULL, 10, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Saint-Hyacinthe','', GETDATE(), NULL, GETDATE(), NULL, 10, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Saint-Jean-sur-Richelieu','', GETDATE(), NULL, GETDATE(), NULL, 10, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Sept-lles','', GETDATE(), NULL, GETDATE(), NULL, 10, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Sherbrooke','', GETDATE(), NULL, GETDATE(), NULL, 10, '', 'Y', '')

INSERT INTO dbo.WRREGION VALUES ('La Ronge','', GETDATE(), NULL, GETDATE(), NULL, 11, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Meadow Lake','', GETDATE(), NULL, GETDATE(), NULL, 11, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Nipawin','', GETDATE(), NULL, GETDATE(), NULL, 11, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Prince Albert','', GETDATE(), NULL, GETDATE(), NULL, 11, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Regina Area','', GETDATE(), NULL, GETDATE(), NULL, 11, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Saskatoon','', GETDATE(), NULL, GETDATE(), NULL, 11, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Swift Current','', GETDATE(), NULL, GETDATE(), NULL, 11, '', 'Y', '')

INSERT INTO dbo.WRREGION VALUES ('Northwest Territories','', GETDATE(), NULL, GETDATE(), NULL, 12, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Nunavut','', GETDATE(), NULL, GETDATE(), NULL, 12, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES ('Yukon','', GETDATE(), NULL, GETDATE(), NULL, 12, '', 'Y', '')

INSERT INTO dbo.WRREGION VALUES (N'Miền Bắc','', GETDATE(), NULL, GETDATE(), NULL, 13, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES (N'Miền Trung','', GETDATE(), NULL, GETDATE(), NULL, 13, '', 'Y', '')
INSERT INTO dbo.WRREGION VALUES (N'Miền Nam','', GETDATE(), NULL, GETDATE(), NULL, 13, '', 'Y', '')

--SELECT * FROM dbo.WRCITY

INSERT INTO dbo.WRCITY VALUES ('Edmonton','',GETDATE(), NULL, GETDATE(), NULL, 3, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('St. Albert','',GETDATE(), NULL, GETDATE(), NULL, 3, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Strathcona Country','',GETDATE(), NULL, GETDATE(), NULL, 3, '', 'Y', '')

INSERT INTO dbo.WRCITY VALUES ('100 Mile House','',GETDATE(), NULL, GETDATE(), NULL, 10, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Quesnel','',GETDATE(), NULL, GETDATE(), NULL, 10, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Williams Lake','',GETDATE(), NULL, GETDATE(), NULL, 10, '', 'Y', '')

INSERT INTO dbo.WRCITY VALUES ('Campbell River','',GETDATE(), NULL, GETDATE(), NULL, 11, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Comox/Courtenay/Cumberland','',GETDATE(), NULL, GETDATE(), NULL, 11, '', 'Y', '')

INSERT INTO dbo.WRCITY VALUES ('Abbotsford','',GETDATE(), NULL, GETDATE(), NULL, 14, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Chilliwack','',GETDATE(), NULL, GETDATE(), NULL, 14, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Hope/Kent','',GETDATE(), NULL, GETDATE(), NULL, 14, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Mission','',GETDATE(), NULL, GETDATE(), NULL, 14, '', 'Y', '')

INSERT INTO dbo.WRCITY VALUES ('Burnaby / New Westminster','',GETDATE(), NULL, GETDATE(), NULL, 15, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Delta / Surrey/Langley','',GETDATE(), NULL, GETDATE(), NULL, 15, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Downtown-West End','',GETDATE(), NULL, GETDATE(), NULL, 15, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('North Shore','',GETDATE(), NULL, GETDATE(), NULL, 15, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Richmond','',GETDATE(), NULL, GETDATE(), NULL, 15, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Tricities / Pitt / Maple','',GETDATE(), NULL, GETDATE(), NULL, 15, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('UBC','',GETDATE(), NULL, GETDATE(), NULL, 15, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Vancouver','',GETDATE(), NULL, GETDATE(), NULL, 15, '', 'Y', '')

INSERT INTO dbo.WRCITY VALUES ('Penticton','',GETDATE(), NULL, GETDATE(), NULL, 17, '', 'Y', '')

INSERT INTO dbo.WRCITY VALUES ('Dawson Creek','',GETDATE(), NULL, GETDATE(), NULL, 20, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Fort St. John','',GETDATE(), NULL, GETDATE(), NULL, 20, '', 'Y', '')

INSERT INTO dbo.WRCITY VALUES ('Parksville / Qualicum Beach','',GETDATE(), NULL, GETDATE(), NULL, 21, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Port Alberni','',GETDATE(), NULL, GETDATE(), NULL, 21, '', 'Y', '')

INSERT INTO dbo.WRCITY VALUES ('Burns Lake','',GETDATE(), NULL, GETDATE(), NULL, 26, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Houston','',GETDATE(), NULL, GETDATE(), NULL, 26, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Kitimat','',GETDATE(), NULL, GETDATE(), NULL, 26, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Prince Rupert','',GETDATE(), NULL, GETDATE(), NULL, 26, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Smithers','',GETDATE(), NULL, GETDATE(), NULL, 26, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Terrace','',GETDATE(), NULL, GETDATE(), NULL, 26, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Vanderhoof','',GETDATE(), NULL, GETDATE(), NULL, 26, '', 'Y', '')

INSERT INTO dbo.WRCITY VALUES ('Brandon','',GETDATE(), NULL, GETDATE(), NULL, 31, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Portage la Prairie','',GETDATE(), NULL, GETDATE(), NULL, 31, '', 'Y', '')

INSERT INTO dbo.WRCITY VALUES ('Goose Bay','',GETDATE(), NULL, GETDATE(), NULL, 43, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Labrador City','',GETDATE(), NULL, GETDATE(), NULL, 43, '', 'Y', '')

INSERT INTO dbo.WRCITY VALUES ('Bedford','',GETDATE(), NULL, GETDATE(), NULL, 48, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('City of Halifax','',GETDATE(), NULL, GETDATE(), NULL, 48, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Cole Harbour','',GETDATE(), NULL, GETDATE(), NULL, 48, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Dartmouth','',GETDATE(), NULL, GETDATE(), NULL, 48, '', 'Y', '')

INSERT INTO dbo.WRCITY VALUES ('Belleville','',GETDATE(), NULL, GETDATE(), NULL, 53, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Trenton','',GETDATE(), NULL, GETDATE(), NULL, 53, '', 'Y', '')

INSERT INTO dbo.WRCITY VALUES ('Kingston','',GETDATE(), NULL, GETDATE(), NULL, 62, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Napanee','',GETDATE(), NULL, GETDATE(), NULL, 62, '', 'Y', '')

INSERT INTO dbo.WRCITY VALUES ('Cambridge','',GETDATE(), NULL, GETDATE(), NULL, 63, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Kitchener / Waterloo','',GETDATE(), NULL, GETDATE(), NULL, 63, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Stratford','',GETDATE(), NULL, GETDATE(), NULL, 63, '', 'Y', '')

INSERT INTO dbo.WRCITY VALUES ('Gatineau','',GETDATE(), NULL, GETDATE(), NULL, 69, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Ottawa','',GETDATE(), NULL, GETDATE(), NULL, 69, '', 'Y', '')

INSERT INTO dbo.WRCITY VALUES ('Kawartha Lakes','',GETDATE(), NULL, GETDATE(), NULL, 71, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Peterborough','',GETDATE(), NULL, GETDATE(), NULL, 71, '', 'Y', '')

INSERT INTO dbo.WRCITY VALUES ('Pembroke','',GETDATE(), NULL, GETDATE(), NULL, 72, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Petawawa','',GETDATE(), NULL, GETDATE(), NULL, 72, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Renfrew','',GETDATE(), NULL, GETDATE(), NULL, 72, '', 'Y', '')

INSERT INTO dbo.WRCITY VALUES ('Grand Bend','',GETDATE(), NULL, GETDATE(), NULL, 73, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Sarnia','',GETDATE(), NULL, GETDATE(), NULL, 73, '', 'Y', '')

INSERT INTO dbo.WRCITY VALUES ('City of Toronto','',GETDATE(), NULL, GETDATE(), NULL, 79, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Markham / York Region','',GETDATE(), NULL, GETDATE(), NULL, 79, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Mississauga / Peel Region','',GETDATE(), NULL, GETDATE(), NULL, 79, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Oakville / Halton Region','',GETDATE(), NULL, GETDATE(), NULL, 79, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Oshawa / Durham Region','',GETDATE(), NULL, GETDATE(), NULL, 79, '', 'Y', '')

INSERT INTO dbo.WRCITY VALUES ('Chartlottetown','',GETDATE(), NULL, GETDATE(), NULL, 82, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Summerside','',GETDATE(), NULL, GETDATE(), NULL, 82, '', 'Y', '')

INSERT INTO dbo.WRCITY VALUES ('Rouyn-Noranda','',GETDATE(), NULL, GETDATE(), NULL, 83, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Val D Or','',GETDATE(), NULL, GETDATE(), NULL, 83, '', 'Y', '')

INSERT INTO dbo.WRCITY VALUES ('Drummondville','',GETDATE(), NULL, GETDATE(), NULL, 85, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Victoriaville','',GETDATE(), NULL, GETDATE(), NULL, 85, '', 'Y', '')

INSERT INTO dbo.WRCITY VALUES ('Lévis','',GETDATE(), NULL, GETDATE(), NULL, 86, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('St-Georges-de-Beauce','',GETDATE(), NULL, GETDATE(), NULL, 86, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Thetford Mines','',GETDATE(), NULL, GETDATE(), NULL, 86, '', 'Y', '')

INSERT INTO dbo.WRCITY VALUES ('City of Montréal','',GETDATE(), NULL, GETDATE(), NULL, 90, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Laval / North Shore','',GETDATE(), NULL, GETDATE(), NULL, 90, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Longueuil / South Shore','',GETDATE(), NULL, GETDATE(), NULL, 90, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('West Island','',GETDATE(), NULL, GETDATE(), NULL, 90, '', 'Y', '')

INSERT INTO dbo.WRCITY VALUES ('Shawinigan','',GETDATE(), NULL, GETDATE(), NULL, 93, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Trois-Rivières','',GETDATE(), NULL, GETDATE(), NULL, 93, '', 'Y', '')

INSERT INTO dbo.WRCITY VALUES ('Lac-Saint-Jean','',GETDATE(), NULL, GETDATE(), NULL, 96, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Saguenay','',GETDATE(), NULL, GETDATE(), NULL, 96, '', 'Y', '')

INSERT INTO dbo.WRCITY VALUES ('Moose Jaw','',GETDATE(), NULL, GETDATE(), NULL, 105, '', 'Y', '')
INSERT INTO dbo.WRCITY VALUES ('Regina','',GETDATE(), NULL, GETDATE(), NULL, 105, '', 'Y', '')

INSERT INTO dbo.WRCITY VALUES ('Yellowknife','',GETDATE(), NULL, GETDATE(), NULL, 108, '', 'Y', '')

INSERT INTO dbo.WRCITY VALUES ('Lqaluit','',GETDATE(), NULL, GETDATE(), NULL, 109, '', 'Y', '')

INSERT INTO dbo.WRCITY VALUES ('Whitehorse','',GETDATE(), NULL, GETDATE(), NULL, 110, '', 'Y', '')

--SELECT * FROM dbo.WRUSERGROUP
ALTER TABLE dbo.WRUSERGROUP ADD UNIQUE (UserGroupName)
DELETE FROM dbo.WRUSERGROUP

INSERT INTO dbo.WRUSERGROUP VALUES (N'Administrator', GETDATE(), GETDATE(), N'', 1, 'Y', N'administrator')
INSERT INTO dbo.WRUSERGROUP VALUES (N'Moderator', GETDATE(), GETDATE(), N'', 1, 'Y', N'moderator')
INSERT INTO dbo.WRUSERGROUP VALUES (N'Member', GETDATE(), GETDATE(), N'', 1, 'Y', N'member')
INSERT INTO dbo.WRUSERGROUP VALUES (N'Quản trị viên', GETDATE(), GETDATE(), N'', 2, 'Y', N'quan-tri-vien')
INSERT INTO dbo.WRUSERGROUP VALUES (N'Quản trị nội dung', GETDATE(), GETDATE(), N'', 2, 'Y', N'quan-tri-noi-dung')
INSERT INTO dbo.WRUSERGROUP VALUES (N'Thành viên', GETDATE(), GETDATE(), N'', 2, 'Y', N'thanh-vien')

--SELECT * FROM dbo.WRUSER

INSERT INTO dbo.WRUSER VALUES  ( N'administrator', N'123456', N'', N'', NULL, N'administrator@abc.com', N'', N'', N'', N'', N'', 1, 1, GETDATE(), GETDATE(), NULL, N'', N'', 'Y')
INSERT INTO dbo.WRUSER VALUES  ( N'moderator', N'123456', N'', N'', NULL, N'moderator@abc.com', N'', N'', N'', N'', N'', 1, 2, GETDATE(), GETDATE(), NULL, N'', N'', 'Y')
INSERT INTO dbo.WRUSER VALUES  ( N'member', N'123456', N'', N'', NULL, N'member@abc.com', N'', N'', N'', N'', N'', 1, 3, GETDATE(), GETDATE(), NULL, N'', N'', 'Y')

INSERT INTO dbo.WRUSER VALUES  ( N'quantri', N'123456', N'', N'', NULL, N'quantri@abc.com', N'', N'', N'', N'', N'', 1, 4, GETDATE(), GETDATE(), NULL, N'', N'', 'Y')
INSERT INTO dbo.WRUSER VALUES  ( N'quanly', N'123456', N'', N'', NULL, N'quanly@abc.com', N'', N'', N'', N'', N'', 1, 5, GETDATE(), GETDATE(), NULL, N'', N'', 'Y')
INSERT INTO dbo.WRUSER VALUES  ( N'thanhvien', N'123456', N'', N'', NULL, N'thanhvien@abc.com', N'', N'', N'', N'', N'', 1, 6, GETDATE(), GETDATE(), NULL, N'', N'', 'Y')

--SELECT * FROM dbo.WRROLE

INSERT INTO dbo.WRROLE VALUES (N'All', GETDATE(), NULL, GETDATE(), NULL, 1, N'', 'Y', 'all')
INSERT INTO dbo.WRROLE VALUES (N'Tất cả', GETDATE(), NULL, GETDATE(), NULL, 2, N'', 'Y', 'tat-ca')

--SELECT * FROM dbo.WRFUNCPAY

INSERT INTO dbo.WRFUNCPAY VALUES (N'Premium', 1, GETDATE(), 1, GETDATE(), 1, N'', 'Y')
INSERT INTO dbo.WRFUNCPAY VALUES (N'Free', 0, GETDATE(), 1, GETDATE(), 1, N'', 'Y')
INSERT INTO dbo.WRFUNCPAY VALUES (N'Thu phí', 1, GETDATE(), 4, GETDATE(), 4, N'', 'Y')
INSERT INTO dbo.WRFUNCPAY VALUES (N'Miễn phí', 0, GETDATE(), 4, GETDATE(), 4, N'', 'Y')

--SELECT * FROM dbo.WRMEDIATYPE

INSERT INTO dbo.WRMEDIATYPE VALUES (N'Picture', GETDATE(), 1, GETDATE(), 1, 1, 2, N'', 'Y', 'picture')
INSERT INTO dbo.WRMEDIATYPE VALUES (N'Video URL', GETDATE(), 1, GETDATE(), 1, 1, 2, N'', 'Y', 'video-url')
INSERT INTO dbo.WRMEDIATYPE VALUES (N'Hình ảnh', GETDATE(), 4, GETDATE(), 4, 2, 4, N'', 'Y', 'picture')
INSERT INTO dbo.WRMEDIATYPE VALUES (N'Đường dẫn video', GETDATE(), 4, GETDATE(), 4, 2, 4, N'', 'Y', 'duong-dan-video')

--SELECT * FROM dbo.WRURGENT

INSERT INTO dbo.WRURGENT VALUES (N'Urgent', GETDATE(), 1, GETDATE(), 1, 0, 1, N'', 1, 'Y', 'urgent')
INSERT INTO dbo.WRURGENT VALUES (N'Normal', GETDATE(), 1, GETDATE(), 1, 0, 2, N'', 1, 'Y', 'normal')
INSERT INTO dbo.WRURGENT VALUES (N'Ưu tiên', GETDATE(), 4, GETDATE(), 4, 0, 3, N'', 2, 'Y', 'uu-tien')
INSERT INTO dbo.WRURGENT VALUES (N'Thông thường', GETDATE(), 4, GETDATE(), 4, 0, 4, N'', 2, 'Y', 'thong-thuong')

--SELECT * FROM dbo.WRENTTYPE

INSERT INTO dbo.WRENTTYPE VALUES (N'Buy', GETDATE(), 1, GETDATE(), 1, 1, N'', 'Y', 'buy')
INSERT INTO dbo.WRENTTYPE VALUES (N'Sell', GETDATE(), 1, GETDATE(), 1, 1, N'', 'Y', 'sell')
INSERT INTO dbo.WRENTTYPE VALUES (N'Ad', GETDATE(), 1, GETDATE(), 1, 1, N'', 'Y', 'ad')
INSERT INTO dbo.WRENTTYPE VALUES (N'Cần mua', GETDATE(), 4, GETDATE(), 4, 2, N'', 'Y', 'can-mua')
INSERT INTO dbo.WRENTTYPE VALUES (N'Cần bán', GETDATE(), 4, GETDATE(), 4, 2, N'', 'Y', 'can-ban')
INSERT INTO dbo.WRENTTYPE VALUES (N'Quảng cáo', GETDATE(), 4, GETDATE(), 4, 2, N'', 'Y', 'quang-cao')

--SELECT * FROM dbo.WRENTSALETYPE

INSERT INTO dbo.WRENTSALETYPE VALUES (N'Company', GETDATE(), 1, GETDATE(), 1, 1, N'', 'Y', 'company')
INSERT INTO dbo.WRENTSALETYPE VALUES (N'Personal', GETDATE(), 1, GETDATE(), 1, 1, N'', 'Y', 'personal')
INSERT INTO dbo.WRENTSALETYPE VALUES (N'Công ty', GETDATE(), 4, GETDATE(), 4, 2, N'', 'Y', 'cong-ty')
INSERT INTO dbo.WRENTSALETYPE VALUES (N'Cá nhân', GETDATE(), 4, GETDATE(), 4, 2, N'', 'Y', 'ca-nhan')

--SELECT * FROM dbo.WRPRICETYPE

INSERT INTO dbo.WRPRICETYPE VALUES (N'Specific', GETDATE(), 1, GETDATE(), 1, 1, N'', 'Y', 'specific')
INSERT INTO dbo.WRPRICETYPE VALUES (N'Deal', GETDATE(), 1, GETDATE(), 1, 1, N'', 'Y', 'deal')
INSERT INTO dbo.WRPRICETYPE VALUES (N'Thỏa thuận', GETDATE(), 4, GETDATE(), 4, 2, N'', 'Y', 'thoa-thuan')
INSERT INTO dbo.WRPRICETYPE VALUES (N'Chi tiết', GETDATE(), 4, GETDATE(), 4, 2, N'', 'Y', 'chi-tiet')

--SELECT * FROM dbo.WRROLEAPPLY

INSERT INTO dbo.WRROLEAPPLY VALUES (1, 1, GETDATE(), 1, GETDATE(), 1, N'', 'Y')
INSERT INTO dbo.WRROLEAPPLY VALUES (4, 2, GETDATE(), 4, GETDATE(), 4, N'', 'Y')


--SELECT * FROM dbo.WRCATEGORY

INSERT INTO dbo.WRCATEGORY VALUES (N'Fashions', GETDATE(), 1, GETDATE(), 1, 1, N'', 'Y', 'fashions')
INSERT INTO dbo.WRCATEGORY VALUES (N'Jobs', GETDATE(), 1, GETDATE(), 1, 1, N'', 'Y', 'jobs')
INSERT INTO dbo.WRCATEGORY VALUES (N'Pets', GETDATE(), 1, GETDATE(), 1, 1, N'', 'Y', 'pets')
INSERT INTO dbo.WRCATEGORY VALUES (N'Services', GETDATE(), 1, GETDATE(), 1, 1, N'', 'Y', 'services')
INSERT INTO dbo.WRCATEGORY VALUES (N'Transport', GETDATE(), 1, GETDATE(), 1, 1, N'', 'Y', 'transport')

INSERT INTO dbo.WRCATEGORY VALUES (N'Dịch vụ', GETDATE(), 1, GETDATE(), 4, 2, N'', 'Y', 'dich-vu')
INSERT INTO dbo.WRCATEGORY VALUES (N'Thời trang', GETDATE(), 1, GETDATE(), 4, 2, N'', 'Y', 'thoi-trang')
INSERT INTO dbo.WRCATEGORY VALUES (N'Vật nuôi', GETDATE(), 1, GETDATE(), 4, 2, N'', 'Y', 'vat-nuoi')
INSERT INTO dbo.WRCATEGORY VALUES (N'Việc làm', GETDATE(), 1, GETDATE(), 4, 2, N'', 'Y', 'viec-lam')
INSERT INTO dbo.WRCATEGORY VALUES (N'Xe & Ôtô', GETDATE(), 1, GETDATE(), 4, 2, N'', 'Y', 'xe-oto')

--SELECT * FROM dbo.WRCATEGORYLV1

insert INTO dbo.WRCATEGORYLV1 VALUES (N'Clothes', GETDATE(), 1, GETDATE(), 1, 1, '', 'Y', 'clothes')
insert INTO dbo.WRCATEGORYLV1 VALUES (N'Doctor', GETDATE(), 1, GETDATE(), 1, 2, '', 'Y', 'clothes')
insert INTO dbo.WRCATEGORYLV1 VALUES (N'IT Software', GETDATE(), 1, GETDATE(), 1, 2, '', 'Y', 'clothes')
insert INTO dbo.WRCATEGORYLV1 VALUES (N'Dog', GETDATE(), 1, GETDATE(), 1, 3, '', 'Y', 'clothes')
insert INTO dbo.WRCATEGORYLV1 VALUES (N'Cat', GETDATE(), 1, GETDATE(), 1, 3, '', 'Y', 'clothes')
insert INTO dbo.WRCATEGORYLV1 VALUES (N'Travel', GETDATE(), 1, GETDATE(), 1, 4, '', 'Y', 'clothes')
insert INTO dbo.WRCATEGORYLV1 VALUES (N'Hotel', GETDATE(), 1, GETDATE(), 1, 4, '', 'Y', 'clothes')
insert INTO dbo.WRCATEGORYLV1 VALUES (N'Cars', GETDATE(), 1, GETDATE(), 1, 5, '', 'Y', 'clothes')
